import quandl
import pandas as pd
import matplotlib.pyplot as plt
pd.set_option('display.max_columns', None)  # or 1000
pd.set_option('display.max_rows', None)

quandl.ApiConfig.api_key='h6ozooCMxqLXz_Ch54Fs'

# data = quandl.get(["NSE/YESBANK"], start_date="2010-02-18", end_date="2020-02-18")
# data

df=pd.read_csv('A_EQUITY_ACTIVE.CSV')
df

for id in df['Security Id']:
    try:
        data = quandl.get(["NSE/{}".format(id)], start_date="2010-02-18", end_date="2020-02-18")
        print(id)
        a=data['NSE/{} - Open'.format(id)]
        plt.figure(figsize=(20,5))
        plt.title(id)
        plt.plot(a)
        plt.show()
    except Exception as e:
        pass
plt.show()

JPASSOCIAT

RPOWER

SUZLON

IDEA

TRIDENT

IFCI

JISLJALEQS

RELCAPITAL

SREINFRA

SOUTHBANK

	Unnamed: 0	Security Code	Security Id	Security Name	dayHigh	dayLow	52weekHigh	52weekLow
0	291	532532	JPASSOCIAT	JAIPRAKASH ASSOCIATES LTD.	1.77	1.47	7.15	1.47
1	350	532939	RPOWER	RELIANCE POWER LTD.	1.77	1.68	13.25	1.46
2	305	532667	SUZLON	SUZLON ENERGY LTD.	2.33	2.22	8.40	1.80
3	329	532822	IDEA	Vodafone Idea Ltd	3.28	2.83	21.32	2.61
4	194	521064	TRIDENT	TRIDENT LTD.	5.70	5.55	8.45	5.22
5	24	500106	IFCI	IFCI LTD.	6.05	5.78	14.58	5.62
6	48	500219	JISLJALEQS	JAIN IRRIGATION SYSTEMS LTD.	6.60	6.32	64.65	6.32
7	27	500111	RELCAPITAL	RELIANCE CAPITAL LTD.	7.14	6.75	214.30	6.71
8	209	523756	SREINFRA	SREI INFRASTRUCTURE FINANCE LTD.	8.33	8.05	33.80	7.17
9	252	532218	SOUTHBANK	SOUTH INDIAN BANK LTD.	9.87	9.62	18.55	8.50
10	266	532388	IOB	INDIAN OVERSEAS BANK	10.00	9.03	15.80	8.75
11	165	511072	DHFL	DEWAN HOUSING FINANCE CORPORATION LTD.	10.34	9.87	176.40	9.41
12	333	532839	DISHTV	DISH TV INDIA LTD.	11.32	10.74	42.35	10.35
13	284	532505	UCOBANK	UCO BANK	13.90	13.50	22.20	11.00
14	276	532480	ALBK	ALLAHABAD BANK	14.60	13.75	58.80	13.75
15	268	532418	ANDHRABANK	ANDHRA BANK	15.25	14.50	33.30	14.50
16	341	532885	CENTRALBK	CENTRAL BANK OF INDIA	16.75	16.30	36.95	15.55
17	44	500183	HFCL	HFCL Ltd	17.15	16.70	25.30	16.20
18	386	534690	LAKSHVILAS	LAKSHMI VILAS BANK LTD.	17.40	17.15	97.35	13.35
19	388	534809	PCJEWELLER	PC JEWELLER LTD.	17.80	17.00	167.60	16.80
20	178	513377	MMTC	MMTC LTD.	19.50	18.80	29.90	14.00
21	249	532209	J&KBANK	JAMMU & KASHMIR BANK LTD.	19.65	17.50	65.95	17.05
22	130	501150	CENTRUM	CENTRUM CAPITAL LTD.	20.10	18.70	36.25	17.90
23	246	532179	CORPBANK	CORPORATION BANK	21.20	20.30	32.15	13.60
24	378	533400	FCONSUMER	Future Consumer Ltd	21.50	21.10	51.70	20.95
25	360	533098	NHPC	NHPC LTD.	22.15	21.10	29.00	20.85
26	80	500390	RELINFRA	RELIANCE INFRASTRUCTURE LTD.	22.25	20.90	146.25	18.00
27	255	532276	SYNDIBANK	SYNDICATE BANK	22.35	21.20	46.60	21.20
28	366	533162	HATHWAY	Hathway Cable & Datacom Ltd	23.10	21.75	38.60	17.55
29	316	532754	GMRINFRA	GMR INFRASTRUCTURE LTD.	23.10	22.00	25.00	14.05
30	368	533206	SJVN	SJVN Ltd	25.65	24.75	27.75	22.25
31	323	532800	TV18BRDCST	TV18 BROADCAST LTD.	30.10	27.35	39.30	18.05
32	385	534309	NBCC	NBCC (India) Ltd	30.55	28.50	68.35	28.50
33	436	540530	HUDCO	Housing and Urban Development Corporation Ltd	33.90	32.55	47.70	28.70
34	304	532659	IDFC	IDFC LIMITED	34.25	33.45	48.05	30.80
35	31	500116	IDBI	IDBI BANK LTD.	34.70	33.25	48.10	23.55
36	22	500103	BHEL	BHARAT HEAVY ELECTRICALS LTD.	34.90	33.40	78.75	33.40
37	180	513599	HINDCOPPER	HINDUSTAN COPPER LTD.	35.80	34.65	52.70	27.90
38	302	532648	YESBANK	YES BANK LTD.	37.55	33.70	285.90	29.05
39	399	539083	INOXWIND	Inox Wind Ltd	38.00	37.00	80.75	30.80